Select distinct [Title] as Titolo, [Acronym],
iif(len(URL)=0 and len(imgLogo)>0, [imgLogo]) as [imgLogo1£#£],
iif(len(URL)>0 and len(imgLogo)>0, '') as [gettami£#£],
[Abstract_ita] as [Abstract#],
[start_date] as [Data inizio],[end_date] as [_Data conclusione],
[url_reference] as [URL],
[Large_Description_ita] as [Descrizione££],
[start_date] as [Data iniziale££],
[end_date] as [_Data conclusione££],
[url_reference] as [URL££],
[IPR_Ita] as [IPR (proprietą intellettuale risultati)££],
[achievements_ita] as [Risultati££],
[innovation_Ita] as [Innovazione££],
[keywords] as [keywords££],
ID as [ID££]
from [Progetti-vista]
WHERE (([id_lab]=1)) ORDER BY [start_date] DESC
;
